﻿CREATE TYPE [flcr].[DEVICE_CONFIG_PROPERTY_UDT] AS  TABLE (
    [DEVICE_CONFIG_PROPERTY_ID] INT          NULL,
    [AUDIT_USER]                VARCHAR (50) NULL,
    [AUDIT_DTTM]                DATETIME     NULL,
    [AUDIT_DTTM_TZ]             INT          NULL,
    [AUDIT_MOD_USER]            VARCHAR (50) NULL,
    [AUDIT_MOD_DTTM]            DATETIME     NULL,
    [AUDIT_MOD_DTTM_TZ]         INT          NULL,
    [BUILTIN]                   BIT          NULL,
    [ACTIVE_FLG]                BIT          NULL,
    [SORT_ORDER]                INT          NULL,
    [DEVICE_ID]                 INT          NULL,
    [PVALUE_DEVICE_PROP_TYPE]   INT          NULL,
    [PNAME_DEVICE_PROP_TYPE]    INT          NULL,
    [PARENT_ID]                 INT          NULL,
    [AUTOCOLLECT_DEFAULT_FLG]   BIT          NULL);

